Links episodios

Dataset statistics

Number of variables	4
Number of observations	623
Missing cells	583
Missing cells (%)	23.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	19.6 KiB
Average record size in memory	32.2 B

Variable types

Numeric	4

Alerts

`previousepisode_id` is highly correlated with `nextepisode_id`	High correlation
`nextepisode_id` is highly correlated with `previousepisode_id`	High correlation
`nextepisode_id` has 583 (93.6%) missing values	Missing
`shows_id` is uniformly distributed	Uniform
`shows_id` has unique values	Unique
`episode_id` has unique values	Unique
`previousepisode_id` has unique values	Unique

Reproduction

Analysis started	2022-06-27 20:42:05.775387
Analysis finished	2022-06-27 20:43:03.244076
Duration	57.47 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

shows_id
Real number (ℝ_≥0)

UNIFORM
UNIQUE

Distinct	623
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	311

Minimum	0
Maximum	622
Zeros	1
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	5.0 KiB

Quantile statistics

Minimum	0
5-th percentile	31.1
Q1	155.5
median	311
Q3	466.5
95-th percentile	590.9
Maximum	622
Range	622
Interquartile range (IQR)	311

Descriptive statistics

Standard deviation	179.9888885
Coefficient of variation (CV)	0.5787424069
Kurtosis	-1.2
Mean	311
Median Absolute Deviation (MAD)	156
Skewness	0
Sum	193753
Variance	32396
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	0.2%
418	1	0.2%
411	1	0.2%
412	1	0.2%
413	1	0.2%
414	1	0.2%
415	1	0.2%
416	1	0.2%
417	1	0.2%
419	1	0.2%
Other values (613)	613	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	0.2%
1	1	0.2%
2	1	0.2%
3	1	0.2%
4	1	0.2%
5	1	0.2%
6	1	0.2%
7	1	0.2%
8	1	0.2%
9	1	0.2%

Value	Count	Frequency (%)
622	1	0.2%
621	1	0.2%
620	1	0.2%
619	1	0.2%
618	1	0.2%
617	1	0.2%
616	1	0.2%
615	1	0.2%
614	1	0.2%
613	1	0.2%

episode_id
Real number (ℝ_≥0)

UNIQUE

Distinct	623
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	45929.2825

Minimum	802
Maximum	62764
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.0 KiB

Quantile statistics

Minimum	802
5-th percentile	15332.8
Q1	42833.5
median	50918
Q3	52740
95-th percentile	59396.2
Maximum	62764
Range	61962
Interquartile range (IQR)	9906.5

Descriptive statistics

Standard deviation	12728.45241
Coefficient of variation (CV)	0.2771315317
Kurtosis	2.605927473
Mean	45929.2825
Median Absolute Deviation (MAD)	3891
Skewness	-1.730461975
Sum	28613943
Variance	162013500.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41648	1	0.2%
49484	1	0.2%
54837	1	0.2%
62306	1	0.2%
23401	1	0.2%
49721	1	0.2%
60427	1	0.2%
41192	1	0.2%
43883	1	0.2%
45090	1	0.2%
Other values (613)	613	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
802	1	0.2%
1596	1	0.2%
1825	1	0.2%
2266	1	0.2%
2504	1	0.2%
2855	1	0.2%
3734	1	0.2%
4091	1	0.2%
6090	1	0.2%
6097	1	0.2%

Value	Count	Frequency (%)
62764	1	0.2%
62545	1	0.2%
62418	1	0.2%
62306	1	0.2%
62127	1	0.2%
61909	1	0.2%
61755	1	0.2%
61674	1	0.2%
61556	1	0.2%
61536	1	0.2%

previousepisode_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	623
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2142028.751

Minimum	1652175
Maximum	2353919
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.0 KiB

Quantile statistics

Minimum	1652175
5-th percentile	1969230.8
Q1	1992892.5
median	2134173
Q3	2289647.5
95-th percentile	2347856
Maximum	2353919
Range	701744
Interquartile range (IQR)	296755

Descriptive statistics

Standard deviation	144940.6898
Coefficient of variation (CV)	0.06766514677
Kurtosis	-1.430340466
Mean	2142028.751
Median Absolute Deviation (MAD)	145276
Skewness	0.05415212197
Sum	1334483912
Variance	2.100780357 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1988862	1	0.2%
2238897	1	0.2%
2074193	1	0.2%
2345008	1	0.2%
2092041	1	0.2%
2308344	1	0.2%
2300446	1	0.2%
2045788	1	0.2%
2325095	1	0.2%
2353723	1	0.2%
Other values (613)	613	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1652175	1	0.2%
1830496	1	0.2%
1910456	1	0.2%
1943281	1	0.2%
1944215	1	0.2%
1944257	1	0.2%
1945592	1	0.2%
1947707	1	0.2%
1949336	1	0.2%
1949636	1	0.2%

Value	Count	Frequency (%)
2353919	1	0.2%
2353800	1	0.2%
2353723	1	0.2%
2353720	1	0.2%
2353507	1	0.2%
2353074	1	0.2%
2353068	1	0.2%
2353058	1	0.2%
2353014	1	0.2%
2352999	1	0.2%

nextepisode_id
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	40
Distinct (%)	100.0%
Missing	583
Missing (%)	93.6%
Infinite	0
Infinite (%)	0.0%
Mean	2324558.35

Minimum	2164172
Maximum	2353605
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	5.0 KiB

Quantile statistics

Minimum	2164172
5-th percentile	2254771.45
Q1	2325088.25
median	2336399
Q3	2346706.25
95-th percentile	2353257.6
Maximum	2353605
Range	189433
Interquartile range (IQR)	21618

Descriptive statistics

Standard deviation	39671.71146
Coefficient of variation (CV)	0.01706634357
Kurtosis	8.062347074
Mean	2324558.35
Median Absolute Deviation (MAD)	11281.5
Skewness	-2.740791524
Sum	92982334
Variance	1573844690
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
2338353	1	0.2%
2313289	1	0.2%
2259031	1	0.2%
2323925	1	0.2%
2339476	1	0.2%
2341824	1	0.2%
2330176	1	0.2%
2350906	1	0.2%
2326393	1	0.2%
2328642	1	0.2%
Other values (30)	30	4.8%
(Missing)	583	93.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2164172	1	0.2%
2201523	1	0.2%
2257574	1	0.2%
2259031	1	0.2%
2299085	1	0.2%
2309422	1	0.2%
2310102	1	0.2%
2313289	1	0.2%
2320459	1	0.2%
2323925	1	0.2%

Value	Count	Frequency (%)
2353605	1	0.2%
2353554	1	0.2%
2353242	1	0.2%
2353070	1	0.2%
2352602	1	0.2%
2352585	1	0.2%
2351377	1	0.2%
2350906	1	0.2%
2349621	1	0.2%
2348039	1	0.2%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	shows_id	episode_id	previousepisode_id	nextepisode_id
0	0	41648	1988862	None
1	1	52198	1986873	None
2	2	52933	2245512	None
3	3	51336	1964569	None
4	4	54033	2309421	2309422
5	5	61674	2315117	None
6	6	52038	1973545	None
7	7	52373	1984264	None
8	8	55016	2336746	2336747
9	9	57339	2299084	2299085

Last rows

	shows_id	episode_id	previousepisode_id	nextepisode_id
613	613	55288	2301754	None
614	614	44343	2132467	None
615	615	19355	1998683	None
616	616	32649	1949336	None
617	617	34187	1996786	None
618	618	51826	2050241	None
619	619	52847	2001674	None
620	620	53581	2046124	None
621	621	59380	2234297	None
622	622	39441	2194257	None

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows